Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
101 1Z0-068 Which three statements are true about Quality of Service Management (QoS)? (Choose three.) A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool. It requires a resource manager plan to be active on databases managed by QoS. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN. 2, 3, 5 MC edit delete
100 1Z0-068 Which three are among the minimum components in a software image that is part of a Grid Plug and Play (GPnP) profile in Oracle Clusterware? (Choose three.) an operating system version a version of Oracle database server used in Real Application Cluster (RAC) databases software required to configure nodes at startup the GPnP software a file system version used for the software to be installed a version of Automatic Storage Management (ASM) used for the cluster 2, 4, 6 MC edit delete
99 1Z0-068 You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster? Which two elements are required to support this configuration? (Choose two.) a Grid Management Repository database a network interface for ASM and private interconnect traffic a network interface for private interconnect only a network interface for the public network a Grid Management Cluster Health Management (CHM) application server 1, 3 MC edit delete
98 1Z0-068 Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.) ocrcheck ocrcheck -config -local ocrcheck -local ocrcheck -config cluvfy comp ocr -n all -verbose 1, 2, 5 MC edit delete
97 1Z0-068 Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose three.) They can be on a different subnet to the hub nodes. Grid Naming Service (GNS) must exist on one of the leaf nodes. They discover hub nodes automatically at startup. They require direct access to shared storage. They may discover hub nodes without having the DNS delegation configured by network administrators. Oracle database 12c RAC instances may not run on leaf nodes. 3, 5, 6 MC edit delete
96 1Z0-068 Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choosetwo.) crsctl stop crs crsctl stop cluster crsctl disable crs crsctl config crs 1, 3 MC edit delete
95 1Z0-068 For which three entities can the “what-if” command evaluation be used to determine the impact of clusterware management operations in Oracle 12c Clusterware? (Choose three.) Pluggable Databases (PDBs) administrator-defined resources local resources database transactions cluster resources 1, 2, 5 MC edit delete
94 1Z0-068 You created a RAC database with DBCA and decide to verify it. 94-qrac.png The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database. The sales database resource will be restarted automatically after an instance failure. The concurrency values are not shown because sales in not a RAC One Node database. The concurrency values are not shown because sales has only one of its four instances running. 2, 4 MC edit delete
93 1Z0-068 Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.) setting the PARALLEL_DEGREE_POLICY to LIMITED setting the PARALLEL_FORGE_LOCAL to TRUE setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS using a database service to limit the number of instances that participate in parallel execution creating a UNIFORM service for a policy-managed RAC database 1, 4 MC edit delete
92 1Z0-068 You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3. You want to drop PDB_3. Which two statements are true? (Choose two.) PDB_3 must be closed on all CDB1 instances. Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3. CDB1 must be open in restricted mode on all cluster nodes. PDB_3 must be open READ ONLY in all CDB1 instances. Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3. 1, 5 MC edit delete
91 1Z0-068 Examine these commands: 91-qrac.png Clients using this configuration fail over and restart any active queries automatically. Clients using this configuration fail over and restart any active transactions automatically. This configuration will work only for a policy-managed RAC database. The configuration is incomplete because the TNS entry for the preconnected backup session is missing. 4 SC edit delete
90 1Z0-068 You administer a RAC database that currently runs on a four-node cluster but which has three instances. Which two statements are always true about redo logs for this RAC database? (Choose two.) A thread of redo must be created before starting a fourth instance if a thread is not already available. A thread of redo must contain at least two log groups before it can be enabled. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance. All the instances must have the same number of redo log groups and each group must have the same number of redo log members. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL. 1, 2 MC edit delete
89 1Z0-068 Which two statements are tuning recommendations for RAC database? (Choose two.) Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query. Use sequences with CACHE and ORDER, if possible. Use Locally Managed Tablespaces with large uniform extent sizes. Use Locally Managed Tablespaces with autoallocate. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing. Use sequences with CACHE and NOORDER, if possible. 4, 6 MC edit delete
88 1Z0-068 Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.) They are used when an application uses the DBMS_LOCK package for UL lock types. They are used to coordinate the next value for a sequence created with the CACHE and ORDBR clauses. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses. They are used to coordinate access across multiple library caches for the same stored procedure. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution. 2, 4 MC edit delete
87 1Z0-068 Which three are benefits of using RAC databases with multiple instances? (Choose three.) surviving node failures surviving storage network failures surviving interconnect failures automatic workload management for services on local connections automatic workload management for services on Oracle Net connections parallel execution across all instances supporting a balanced policy-management service parallel execution across all instances supporting a singleton policy-management service 2, 3, 4 MC edit delete
86 1Z0-068 Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.) The Interconnects page shows the load contributed by database instances on the public network. The Interconnects page shows the load contributed by database instances on the private interconnect and the public network. The Interconnects page shows throughput contributed by individual sessions on the private interconnect. The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity. The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity. 3, 4 MC edit delete
85 1Z0-068 Which three resources are managed using global concurrency control in an Oracle 12c RAC multi-instance database? (Choose three.) latches enqueues database block buffers mutexes cursors redo log buffers 1, 2, 3 MC edit delete
84 1Z0-068 Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.) gc cr block busy gc current request gc current block busy gc cr request gc current grant busy gc cr grant busy 2, 4 MC edit delete
83 1Z0-068 PROD1, PROD2, and PROD3 are three Instance that have the PROD database open. It shuts down PROD1 and PROD2; OLTP will be started automatically on PROD3. It shuts down PROD1 and PROD2; OLTP will not be started on PROD3. PROD1and PROD2 are not shut down because OLTP must first be stopped. PROD1and PROD2 are not shut down because OLTP must first be manually relocated to PROD3. It shuts down either PROD1or PROD2 but not both, so that OLTP remains available on a preferred instance. 1 SC edit delete
82 1Z0-068 Which three statements are true about an Oracle Database RAC software installation? (Choose three.) The software must be installed into a cluster file system. The software must be installed into a local file system on each node. RAC installations require Oracle Enterprise Edition. Fix-up scripts generated during the installation must be run as root on UNIX platforms. The software can be installed into an ACFS file system. The software must be installed on all nodes in the cluster. SSH user equivalence for the Oracle user can be set up before the software installation. 4, 5, 7 MC edit delete
81 1Z0-068 Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.) All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance. Clustered ASM has GRD resources distributed among all ASM instances RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance. Shadow GRD resources may exist in more than one database instance for a resource. Only one GRD shadow resource may exist for an Enqueue Resource. 2, 4, 6 MC edit delete
80 1Z0-068 Examine this tnsnames entry from a RAC configuration using a SCAN listener: 80-qrac.png The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener. Client connection requests are automatically balanced across all IP addresses defined for the SCAN. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available. 2, 4 MC edit delete
79 1Z0-068 Examine this command: 79-qrac.png It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client. The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service. The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service. It is disabled because the -c1bgoal attribute is set to LONG. The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service. 1, 4 MC edit delete
78 1Z0-068 Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.) They are automatically configured to use Enterprise Manager Express. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation. They can be policy managed. They can be administrator managed. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource. They can have multiple pluggable databases (PDB) when the container database (CDB) is created. 3, 4, 6 MC edit delete
77 1Z0-068 You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners. Which two statements are true regarding client-side connect-time load balancing? (Choose two.) You must add SCAN VIPs to the REMOTE_LISTENER parameter to enable correct listener cross-registration. Client connection requests are automatically load balanced across the IP addresses defined for the SCAN listeners. You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used. The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node. SCAN listeners redirect connection requests to a node listener for the appropriate instance. 2, 5 MC edit delete
76 1Z0-068 Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software? (Choose three.) Oracle Cluster Registry (OCR) files Oracle database executables Grid Infrastructure executables Data files for tablespaces Archive logs Voting Disks 2, 4, 5 MC edit delete
75 1Z0-068 Which three statements are true concerning the behavior of an Oracle Clusterware 12c Flex Cluster in response to hub or leaf node failures? (Choose three.) Leaf nodes evicted from a Flex Cluster always require a reboot. Hug node eviction results in the reboot of all leaf nodes that were connected to the evicted hub node. Hub nodes evicted from a Flex Cluster always require a reboot. Hub node eviction results in the eviction of all leaf nodes that were connected to the evicted hub node. Cluster Resources on a leaf node that is evicted from a Flex Cluster are relocated, if possible, to another leaf node that is connected to same hub node to which the failed leaf node was connected. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to a leaf node that was connected to the evicted hub node. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to another hub node in the cluster. 2, 5, 7 MC edit delete
74 1Z0-068 Examine this command: 74-qrac.png The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate). newtemplate must be defined for the +DATA disk group Existing data files in TBS1 must also use the same template. The +DATA disk group should not be part of Flex ASM. User-defined subdirectories ORCL and USERS must already exist. 3, 4 MC edit delete
73 1Z0-068 You performed these steps to disable an ADVM volume containing an ACFS file system: 73-qrac.png The ACFS file system will be permanently removed from the volume. The ACFS mount registry with Oracle restart is automatically deleted.q The volume can be enabled and the file system can be mounted back again to access the existing data. The ACFS file system will be permanently removed from the volume only if the file system is empty. The disabling of volume does not destroy data in the file system. 3, 5 MC edit delete
72 1Z0-068 Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.) Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported. An ADVM volume cannot be used as a boot device on a leaf node. To use ADVM volumes, an ASM proxy instance is not required on a leaf node. ADVM volumes can be used to store the OCR and voting files to be used by a leaf node. An ADVM volume cannot be used as the root file system on a leaf node. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes. 2, 5, 6 MC edit delete
71 1Z0-068 A clustered ASM Instance has the DATA diskgroup mounted. Which two can be used to display information about databases accessing files in the DATA diskgroup? asmcmd lsct v$session v$process v$asm_client asmcmd lsdg 1, 4 MC edit delete
70 1Z0-068 Which three statements are true about fully qualified file names in ASM? (Choose three.) They are system generated at the time of ASM file creation. They can be used to reference existing ASM files. They can be created only if OMF is enabled. They are the only valid form that can be used for single file creation of a control file. An alias may be created for an existing file by referring to the fully qualified file name. 1, 2, 5 MC edit delete
69 1Z0-068 Examine this command and output: 69-qrac.png The disk group compatibility attribute for ADVM must be set to 12.1 or higher. The parent snapshot must be read-only. The underlying ADVM volume must be configured with high redundancy. The parent snapshot must be read/write. 3 SC edit delete
68 1Z0-068 Which two statements are true about clustered ASM instances? (Choose two.) An ASM instance must store its SPFILE in ASM. The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node. The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances. The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node. The SPFILE must be stored in a diskgroup that is accessible to all ASM instances. 1, 4 MC edit delete
67 1Z0-068 Disk group DGRP1 has these attributes: 67-qrac.png The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group. 2, 3 MC edit delete
66 1Z0-068 Examine the output of the asmcmd and srvct1 commands: 66-qrac.png One ASM instance is shut down and the instance count is reduced by one. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down. The command fails because one ASM instance must be shut down manually before executing the command. The command fails because the instance count cannot be reduced to less than the minimum value of 3. 1 SC edit delete
65 1Z0-068 Which two statements are true about High Availability NFS (HANFS)? (Choose two.) HANFS does not depend on NFS services provided by the underlying operating system. HANFS performance depends on the characteristics of the underlying ASM disks. HANFS provides high availability in case of an NFS client failure. HANFS provides high availability in case of cluster node failure. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem. 2, 3 MC edit delete
64 1Z0-068 You must replace a failed disk that was dropped from a disk group. You want the rebalance operation to occur with minimal performance impact. Which two options exist to achieve this? (Choose two.) Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group. Increase the value of the DISK_REPAIR_TIME attribute for the disk group. Use the WAIT clause with the ALTER DISKGROUP command. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group. Set the POWER clause to 1 in the ALTER DISKGROUP command. 1, 2 MC edit delete
63 1Z0-068 Which two statements are true about Oracle Clustered ASM performance? (Choose two.) Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance. To improve performance a database must have two disk groups; one for data and one for the fast recovery area. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance. All ASM Disks belonging to a disk group should be of the same size for optimal performance. 2, 5 MC edit delete
62 1Z0-068 Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware? (Choose three.) There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless of cluster size. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters are used. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM). 3, 4, 5 MC edit delete
61 1Z0-068 Which two utilities support the “what-if” command evaluation? asmcmd ocrconfig oifcfg crsctl srvctl 4, 5 MC edit delete
60 1Z0-068 Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs? (Choose two.) If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP is required. An application VIP is created on the default network by the appvipcfg utility. An application VIP is created on the interconnect network by the crsctl utility. An application VIP can be created with the crsctl utility. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails. 2, 4 MC edit delete
59 1Z0-068 Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? (Choose two.) at least one for the public network at least one for the storage network at least one for the interconnect at least two for the public network at least two for the storage network at least two for the interconnect 1, 3 MC edit delete
58 1Z0-068 Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware? Use the cluvfy comp command for the specific resource within a component. Use the crsctl set trace res “resource_name=debugging_level” command. Use the crsctl set log res “resource_name=debugging_level2” command. Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected. 2, 3 MC edit delete
57 1Z0-068 When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04? Run ocr.config –repair on another node in the cluster to repair the ocr.loc file on host01 Stop the clusterware stack on host01 only. Stop the clusterware stack on all cluster nodes. Run ocrconfig –repair on host01. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig –repair command. 2, 4 MC edit delete
56 1Z0-068 Which three statements are true about Server Categorization in Oracle 12c Clusterware? All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware. Different Hub nodes in a flex cluster may belong to separate administrator-defined categories. All hub nodes in a flex cluster belong to the same Oracle-supplied category. A server may be added to only one category using the crsctl utility. All leaf nodes in a flex cluster belong to the same Oracle-supplied category. All server attributes used for categorization are administrator modifiable. 3, 5, 6 MC edit delete
55 1Z0-068 Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c? All node evictions require that the evicted node or nodes be rebooted. A node whose performance is severely degraded can be evicted. The OCSSD process may evict a node after an escalation request from a database instance LMON process. The CSSDMONITOR process can request a node eviction. The OCLSKD process is used for node eviction requests originating on the node to be evicted. The reboot advisory broadcasts reboot decisions only over the interconnect. 2, 4, 5 MC edit delete
54 1Z0-068 Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture? Each leaf node must be connected to storage shared across all cluster nodes. Hub nodes require direct access to the voting disks. Each leaf node must be connected to storage shared across all leaf nodes. Each hub node must be connected to storage shared across all hub nodes. Hub nodes require direct access to the OCR file. Leaf nodes require direct access to the voting disks. 2, 4, 5 MC edit delete
53 1Z0-068 Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation? Some grid infrastructure patchsets may not be installed in a rolling fashion. They can be applied in-place. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of the software running anywhere in the cluster When performing rolling patches, the VIPs for the node being patched are relocated to another node. 3 SC edit delete
52 1Z0-068 Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c? (Choose two.) the Grid Naming Service (GNS) VIP public IP addresses High Available VIP (HAIP) addresses Single Client Access Name (SCAN) VIPs Storage Network IP addresses 1, 4 MC edit delete
51 1Z0-068 Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack? asmcmd srvctl predict.... crsctl fail…. asmca acfsutil advmutil 2, 5 MC edit delete
50 1Z0-068 Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation? Some grid infrastructure patchsets may not be installed in a rolling fashion. They can be applied in-place. When performing rolling patches, crsctl query crs software version always displays the lowest version of the software running anywhere in the cluster When performing rolling patches, the VIPs for the node being patched are relocated to another node. 3 SC edit delete
49 1Z0-068 Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? (Choose three.) in-place upgrades using the Oracle Universal Installer out-of-place patching for patch bundles in-place patching for patch bundles out-of-place upgrades using the Oracle Universal Installer in-place patching for one-off patches in-place patching for patch sets 2, 4, 5 MC edit delete
48 1Z0-068 Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster? The hub node is evicted from the cluster Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both. 1, 2, 5 MC edit delete
47 1Z0-068 Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware? When a policy is first created, it is initially active. When a policy is activated, nodes may be reassigned to server pools based on the policy definition. An administrator-defined policy may be activated using the srvctl utility. When a policy is activated, resources cannot be automatically started to comply with the policy definition. When a policy is first created, it is initially inactive. When a policy is activated, resources can be automatically stopped to comply with the policy definition. 2, 3, 5 MC edit delete
46 1Z0-068 Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware? It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect. It has at least two routable interfaces outside the GPnP domain for the public interface. It has at least one routable interface inside the GPnP domain for the private interconnect. It has at least one routable interface outside the GPnP domain for the public interface. It has a unique identifier that is unique outside the GPnP domain. It has a unique identifier that is unique inside the GPnP domain. 4, 6 MC edit delete
45 1Z0-068 Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)? Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03. Run the rootcrs.pl – deconfig –force command as root on host01, or on either host02 or host03. Run the rootcrs.pl – deconfig –force command as root on host04. Run the crsctl unpin css -n host04 command as root on host04 Run the crsctl delete node -n host04 command as root on host04. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03. 3, 6 MC edit delete
44 1Z0-068 Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c? The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner’s environment. The upgrade must be done in-place. The upgrade must be done out of place. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner’s environment. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster. 1, 3, 5, 7 MC edit delete
43 1Z0-068 Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c? an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation an O/S group to own the software inventory an O/S user to own the Oracle Database installation an O/S group called dba a group to own the ASMLIB-provisioned storage a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage 2, 4 MC edit delete
42 1Z0-068 Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system? Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM. Use ocrcheck command to view the location of the OCR only if stored in a file system. Use crsctl querry votedisk to view the location of voting files if stored in ASM. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM. Use crsctl query votedisk to view the location of voting files if stored in a file system. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system. 1, 3, 5 MC edit delete
41 1Z0-068 When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)? using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster using Shared GNS running on another cluster using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster creation of a new GNS for this cluster using DHCP to assign Node Virtual IP addresses for nodes in the cluster 1, 4, 5 MC edit delete
40 1Z0-068 Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c? The installer permits the creation of a disk group for use by the voting disks and OCR file. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node. The installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster. ASM disk groups used for voting files and OCR files require a quorum failgroup. 1, 2 MC edit delete
39 1Z0-068 Which three statements are true about Oracle Clusterware components, architecture, and behavior? The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR). All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP). 3, 4, 6 MC edit delete
38 1Z0-068 Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux? It creates the grid user if not already defined. It modifies the /etc/sysctl.conf Linux file. It installs kernel modules required for the ASM Cluster File System (ACFS). It installs the OpenSSH client package. It creates the oinstall group if not already defined. 2, 5 MC edit delete
37 1Z0-068 Your flex cluster has these attributes: 37-qrac.png It fails because no VIP was specified for the hub node host05. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh. It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hub nodes when using full featured GNS. 1 SC edit delete
36 1Z0-068 Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware? (Choose three.) All server pools in a cluster are controlled by the policy set, when user-defined policy management is used. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used. 1, 3, 5 MC edit delete
35 1Z0-068 Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c? All grid infrastructure patches may be applied in a rolling fashion with Opatch. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes. Opatch can patch all cluster nodes simultaneously only for nonrolling patches. Applying patches with Opatch must be done in an out-of-place fashion. 1 SC edit delete
34 1Z0-068 Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability? A policy-managed resource can be started manually using crsctl. A policy-managed resource can be started manually using srvctl. Resource dependencies are automatically set when using a policy-managed resource. An administrator-managed resource can be started manually using crsctl. An administrator-managed resource can be started manually using srvctl. The action script is automatically set when using a policy-managed resource. 1, 5 MC edit delete
33 1Z0-068 Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 12c Clusterware? A Server Pool an application VIP an application resource a resource dependency definition a script agent 3, 5 MC edit delete
32 1Z0-068 You plan to apply a patchset to a RAC database running on a two-node cluster. 32-qrac.png 1, 3, 2, 5 and 8 3, 2, 5 and 8 1, 2, 3, 5 and 8 3, 2, 6 and 8 3, 2, 5, 2 and 8 1 SC edit delete
31 1Z0-068 Examine this output: 31-qrac.png It succeeds. It fails because the file system must be unmounted before resizing. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL. It succeeds but the file system is automatically unmounted. It fails because the –f option is not specified. 3 SC edit delete
30 1Z0-068 Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? SSH user equivalence for the Oracle software owner must be configured on all cluster nodes. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed. Grid infrastructure must be installed on all cluster nodes. The Clusterware stack must be up on all cluster nodes. 4, 5 MC edit delete
29 1Z0-068 You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2. 29-qrac.png CRM is only available for new logins on the CDB1 instance on host01. CRM is available for new logins on one CDB1 instance. The srvctl start service command automatically opens PDB_1 if not already opened. The srvctl stop service command does not close PDB_1 on any instance of CDB1. The CRM service is not available for new logins on any instance of CDB1. 3, 4, 5 MC edit delete
28 1Z0-068 Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware? Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource. All servers in a new cluster installation belong to the generic server pool. The server pool contains servers that host administrator-defined high availability resources. Server pools must be managed with the srvctl utility for servers hosting a database. All servers in a new cluster installation belong to the free server pool. 3, 4, 5 MC edit delete
27 1Z0-068 A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections. Broken connections must be re-established as quickly as possible. Which feature will support this requirement? Fast Connection Failover (FCF) with Transparent Application Failover (TAF) Transparent Application Failover (TAF) Transparent Application Failover (TAF) using Fast Application Notification (FAN) Fast Connection Failover (FCF) 3 SC edit delete
26 1Z0-068 The DGRP1 diskgroup has these attributes: 26-qrac.png 1, 2, 3, 4, 5, 2, 10, 7 1, 3, 5, 7 1, 8, 6, 3, 5, 8, 9, 7 1, 8, 6, 3, 5, 2, 10, 7 3 SC edit delete
25 1Z0-068 Which two statements are true about ASM alias names? ASM files created using an alias name are not OMF files even if OMF is enabled. Alias file names cannot be used together with templates when creating tablespaces. ASM files created using an alias name are OMF files even if OMF is not enabled. Alias names can be stored only in user-defined directories. ASM files created using an alias name also have a fully qualified name and can be accessed by either name. 3, 5 MC edit delete
24 1Z0-068 Which three statements are true about ASM Cloud File System (ACFS) tagging? acfssettag is a command provided by a platform-independent API to tag files. acfssettag is a command provided by a platform-dependent API to tag files. ACFS tagging is used to mark a subset of files in an ACFS file system for replication. acfsutil encr on can be used to specify the tag names of the files to be encrypted. acfsutil tag set can be used to tag files. 1, 3, 5 MC edit delete
23 1Z0-068 Which three statements are true about Global Resource Management in an Oracle 12c RAC database? Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE. Object remastering causes all blocks in any instance’s buffer cache from the same object to be mastered in the Global Resource Directory (GRD). When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL. Global Enqueue resources are recovered after Global Cache Resources after an instance failure. 2, 3, 4 MC edit delete
22 1Z0-068 PROD1, PROD2 and PROD3 are three active instances of the PROD database. 22-qrac.png PARALLEL_MIN_SERVERS will be 200 for all instances of PROD. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD. The second statement returns an error because this parameter must be identical for all instances. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1. 4 SC edit delete
21 1Z0-068 Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database? creating additional redo threads creating additional undo tablespaces creating shared ASM disk groups adding cluster resources creating database services adding additional initialization parameters 1, 2, 4, 6 MC edit delete
20 1Z0-068 Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment? Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened. Taking an AWR snapshot in a RAC database captures data from the local instance only. Data captured by an AWR is aggregated across all instances before being stored in the database. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot. AWR snapshots are created when control_management_pack_access is set to “none” 1, 4, 5 MC edit delete
19 1Z0-068 Examine this query and output: 19-qrac.png alter sequence seq1 cache 10000; alter sequence seq1 order; alter sequence seq1 noorder; exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’) alter sequence seq1 keep; 1, 3 MC edit delete
18 1Z0-068 Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database? TAF-enabled sessions fail over to a surviving instance accepting logins for the service. TAF-settings for the service override TAF settings in TNS entry used by the client. TAF can restart a query or a transaction after failover. The TAF settings for a client connections overrides any TAF settings in the service definition. TAF PRECONNECT requires configuration for the service and in the client TNS entry. 1, 2, 3 MC edit delete
17 1Z0-068 You plan to create a three-instance RAC database stored in ASM, with its data files in the DATA disk group. Identify three supported storage solutions for the Fast Recovery Area (FRA). a shared nothing file system accessed directly by the database instances a cluster file system a shared NFS file system the DATA disk group a local file system with the same path name on each cluster node 2, 3, 4 MC edit delete
16 1Z0-068 After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource. Which command, or sequence of commands, should you use? srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2 srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server 016n1, 016n2 srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2 3 SC edit delete
15 1Z0-068 Which two statements are true about Quality of Service Management? It can enable a more efficient sharing of hardware resources. It can improve the performance of SQL statements. It can improve system stability as the workload changes. It can improve the performance of PL/SQL. It can reduce the load on the system caused by Oracle background processes. 1, 3 MC edit delete
14 1Z0-068 Which three statements are true about Quality of Service Management (QoS)? A server-pool can be managed by QoS even if it does have database instances running on any server in the pool. It can manage database services only if they are defined as UNIFORM services. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running. It supports multiple databases assigned to the same server pool. Databases managed by QoS can be administrator managed or policy managed. 2, 3, 4 MC edit delete
13 1Z0-068 Which three are benefits of using RAC One Node in Oracle 12c? automatic failover for high availability ability to perform rolling patches online conversion from RAC One Node databases to multi-instance RAC databases load-balancing of services within a single instance online-conversion from non-RAC databases to RAC One Node databases multiple instances of the same database on a single node to protect against instance failure 1, 2, 3 MC edit delete
12 1Z0-068 Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database? using DBCA to migrate the database to shared storage and then start one or more RAC database instances on the cluster using DBCA to create a template from the single-instance database and then to create a RAC database on the cluster using that template using the rconfig utility to create a template from the single-instance database and then using DBCA to create a RAC database on the cluster using that template using the rconfig utility to migrate the database to shared storage and then using DBCA to start one or more RAC database instances on the cluster. 2 SC edit delete
11 1Z0-068 PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs. 11-qrac.png It opens the PRDPDB1 PDB if not already opened. It can open the PRDPDB1 PDB only if it is policy managed. It can open the PRDPDB1 PDB automatically. It can open the PRDPDB1 PDB only if it is manually managed. 2 SC edit delete
10 1Z0-068 Which three statements are true about Oracle 12 RAC Database software installations? It is possible to install RAC database software on a one node cluster. It is possible to install multiple RAC database 12c software homes on the same cluster. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OS users. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RAC database software. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OS user. 1, 2, 4 MC edit delete
9 1Z0-068 Which three options have a RAC-specific tuning component? contention on index leaf blocks sequence definitions the size of the online redo log buffers contention for online redo log files contention for archived redo log files the load on the Cluster Interconnect 1, 3, 6 MC edit delete
8 1Z0-068 You are developing a user callout procedure to send an email to the helpdesk whenever a RAC database instance fails to restart after node failure. 8-qrac.png 1, 3, 7 1, 4, 6 2, 5, 8 2, 4, 7, 8 2, 4, 7 1, 4, 7, 8 6 SC edit delete
7 1Z0-068 Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners? It is based on performance metrics provided by the database instances LREG processes. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN. 3, 5 MC edit delete
6 1Z0-068 Which three statements are true about Oracle Enterprise Manager Topology Viewer? It displays which listeners listen on behalf of which instances. It displays the relationship between targets of different target types in a cluster. It displays the status of all cluster components. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB). It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM. It displays the type of network used by RAC database instance. 1, 2, 5 MC edit delete
5 1Z0-068 Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy. Which two statements are true? The service must be manually restarted with SRVCTL every time the instance hosting the service fails. Clusterware will monitor the service while it is active. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service. When manually started, the service will always start on one or more available instances rather than on their preferred instances. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service. 2, 5 MC edit delete
4 1Z0-068 Examine this command executed on the first node of a three-node cluster: 1-qrac.png It applies a patch to the Grid Infrastructure only on the first cluster node. It applies a patch to the Grid Infrastructure on all cluster nodes. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, only on the first cluster node. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on all cluster nodes. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes. 2, 4 MC edit delete
3 1Z0-068 Which two statements are true about database service administration in a RAC environment? When services are created with srvctl, tnsnames.ora is automatically updated. When services are created with srvctl, the service is not started automatically. Service attributes can be modified, unless an instance hosting the service is in restricted mode. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically synchronized with the changes. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR. When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined. 2, 6 MC edit delete
2 1Z0-068 Which three statements are true regarding multitenant architecture for RAC databases? One UNDO tablespace for each PDB is required. One UNDO tablespace for each instance is required. PDBs can have local temporary tablespaces. All the containers share the same SYSTEM and SYSAUX tablespaces. You can open one, several, or all PDBs on one, several, or all CDB instances. 2, 3, 5 MC edit delete
1 1Z0-068 Which three statements are true about opatch version 12? It can apply patches to a database ORACLE_HOME. It can apply a patchset to a database ORACLE_HOME. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME. It cannot run with root privileges on a Unix-like system. It can apply some patches without shutting down database instances. It can only apply patches on the cluster node from where it is issued. 1, 2, 5 MC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018